<html>
<title>Retribution High Scores</title>
<body>

<?php
$con = mysql_connect("localhost", "solomon", "mikesolomon1");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

mysql_select_db("solomon", $con);

$sql="INSERT INTO highScore (Name, Score)
VALUES
('$_GET[name]','$_GET[score]')";

if (!mysql_query($sql,$con))
  {
  die('Error: ' . mysql_error());
  }
echo "1 record added <br />";

$result = mysql_query("SELECT * FROM highScore ORDER BY score DESC");

echo "<table border='1'>
<tr>
<th>Firstname</th>
<th>Score</th>
</tr>";

while($row = mysql_fetch_array($result))
  {
  echo "<tr>";
  echo "<td>" . $row['Name'] . "</td>";
  echo "<td>" . $row['Score'] . "</td>";
  echo "</tr>";
  }
echo "</table>";
mysql_free_result($result);
mysql_close($con)
?>

</body>
</html>
